package com.lu.mapper;

import com.lu.entity.Live;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface LiveMapper {
    //查询所有入住信息
    List<Live> selectAllLive();

    //根据id删除入住数据
    @Delete("delete from student_accommodation where id = #{id}")
    void deleteLiveById(int id);

    //根据id查询入住数据
    List<Live> findLiveById(Integer id);

    //修改入住数据
    void updateLiveData(Live live);

    //添加入住数据
    void insertLiveData(Live live);

    //模糊查询
    List<Live> findLive(Live live);
}
